Save
Ask
Tour
Hide
$1,200,000
3 Days On Site
54182 Queensborough DriveShelby Charter Township, MI 48315
For Sale|Single Family Residence|Active
5
Beds
5
Total Baths
4
Full Baths
1
Partial Bath
6,340
SqFt
$189
/SqFt
1997
Built
Subdivision:
LAKE IN THE WOODS SUB
County:
Macomb
Due to the health concerns created by Coronavirus we are offering personal 1-1 online video walkthough tours where possible.
Call Now: 248-213-8606
Is this the listing for you? We can help make it yours.
248-213-8606Upcoming Open Houses
Due to COVID-19, we recommend you verify Open Houses before attending.
Fri, May 1, 4:00 PM - 6:00 PM
Sat, May 2, 12:00 PM - 2:00 PM
Sun, May 3, 1:00 PM - 3:00 PM
Save
Ask
Tour
Hide
This stunning colonial in the highly sought-after Lake in the Woods subdivision of Shelby Township. Featuring 5 bedrooms, 4 bathrooms, and LAKE ACCESS. This home provides over 4,000 square feet of above-grade living space with a well-designed layout ideal for both everyday living and entertaining. The home is further enhanced with a finished walkout basement with an additional 2,280 square feet of living space including a second kitchen, living room, bedroom, and full bathroom! Step outside to your private backyard retreat complete with an in-ground pool, perfect for summer entertaining and relaxing in a serene setting.
Save
Ask
Tour
Hide
Listing Snapshot
Price
$1,200,000
Days On Site
3 Days
Bedrooms
5
Inside Area (SqFt)
6,340 sqft
Total Baths
5
Full Baths
4
Partial Baths
1
Lot Size
0.51 Acres
Year Built
1997
MLS® Number
20261024326
Status
Active
Property Tax
$14,168.29
HOA/Condo/Coop Fees
$54.17 monthly
Sq Ft Source
N/A
Friends & Family
Recent Activity
| 4 days ago | Status changed to Active | |
| 4 days ago | Listing updated with changes from the MLS® | |
| 4 days ago | Listing first seen on site |
General Features
Acres
0.51
Attached Garage
Yes
Cross Street
25 MILE RD AND JEWELL
Disclosures
Exclusions Do Not Exist, No Restrictions, Taxes Not Homestead Exempt
Garage
Yes
Garage Spaces
3.5
Levels
Two
Parking
Attached
Property Sub Type
Single Family Residence
Sewer
Public Sewer
Special Circumstances
Standard
SqFt Above
4060
SqFt Below
2280
Style
Colonial
Water Source
Public
Interior Features
Appliances
Gas Water HeaterDishwasherDisposalFree-Standing Refrigerator
Basement
Finished
Cooling
Central Air
Heating
Forced AirNatural Gas
BathDualEntry
Dimensions - 8 X 6Level - Second
BathFull
Dimensions - 5 X 7Level - Basement
BathLav
Dimensions - 6 X 6
Bedroom
Dimensions - 14 X 12Level - Second
Dining Room
Dimensions - 14 X 13Level - Second
Family Room
Dimensions - 22 X 18
Kitchen
Dimensions - 28 X 15Level - Second
Laundry
Dimensions - 8 X 7
Library
Dimensions - 18 X 15Level - Second
Living Room
Dimensions - 16 X 14
Master Bathroom
Dimensions - 18 X 17Level - Second
Master Bedroom
Dimensions - 18 X 7Level - Second
Save
Ask
Tour
Hide
Exterior Features
Construction Details
Brick
Pool Features
In Ground
Roof
Asphalt
Waterfront Features
Lake Privileges
Community Features
Association Dues
650
Building Access
GroundLevel
Financing Terms Available
CashConventional
HOA Fee Frequency
Annually
MLS Area
Area03071ShelbyTwp
Roads
Paved
School District
Utica
Schools
School District
Utica
Elementary School
Unknown
Middle School
Unknown
High School
Unknown
Listing courtesy of Summit Union Real Estate: [email protected]
IDX provided courtesy of Realcomp II Ltd. via RealcompIILtd. Copyright © 2026 Realcomp II Ltd. Shareholders.
IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing and that the data is deemed reliable but not guaranteed accurate by the MLS.
IDX provided courtesy of Realcomp II Ltd. via RealcompIILtd. Copyright © 2026 Realcomp II Ltd. Shareholders.
IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing and that the data is deemed reliable but not guaranteed accurate by the MLS.
Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Did you know? You can invite friends and family to your search. They can join your search, rate and discuss listings with you.